import os
import configparser

base_dir = os.path.dirname(os.path.abspath(__file__))
file_path = os.path.join(base_dir, 'mysql.ini')

config = configparser.ConfigParser()
config.read(file_path, encoding='utf-8')

# 1.获取所有节点
v1 = config.sections()
print(v1)  # ['server', 'client']

# 2.获取节点下的键值
v2 = config.items('server')
for k, v in v2:
    print(k, v)

# 3.节点下的某个键对应的值
v3 = config.get("server", "vv3")
print(v3)

# 4.是否存在某个节点
# v4 = config.has_section('server')
# print(v4)

# 5.添加节点
# config.add_section("group")
# config.set("group", 'name', "wupeiqi")
# config.set("group", 'age', "19")
# with open(file_path, mode='w', encoding='utf-8') as f:
#     config.write(f)

# 6.删除节点
# config.remove_section("client")
# with open(file_path, mode='w', encoding='utf-8') as f:
#     config.write(f)

# 6.删除键值
# config.remove_option("server", 'v2')
# with open(file_path, mode='w', encoding='utf-8') as f:
#     config.write(f)

# 7.修改
# config.set("server", 'v1', "哈哈哈哈")
# with open(file_path, mode='w', encoding='utf-8') as f:
#     config.write(f)
